<?xml version="1.0" encoding="UTF-8"?>
<chartData>
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年个人任务完成百分比统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@USERNAME@任务完成百分比统计"  baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />   
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Multi-series Column 2D</chartCode>
    <chartName>按年个人日志完成统计多系列柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		   	<chart palette="2" caption="@YEAR@年@USERNAME@日志完成统计" shownames="1" showvalues="0"   useRoundEdges="1" legendBorderAlpha="0" baseFontSize="12">
				<categories>
				<category label="已写日志" />
				<category label="补写日志" />
				</categories>
				<dataset seriesName="@LASTYEAR@" color="F6BD0F" showValues="0">
				<set value="sql(select count(*) from worklog where user_id = @USERID@ and STATUS=1   and datediff(day, convert(datetime, log_day) , create_date) = 0  and year(log_day) = @LASTYEAR@,%%)" />
				<set value="sql(select count(*)  from worklog where user_id = @USERID@ and STATUS=1  and datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day) = @LASTYEAR@,%%)" />
				</dataset>
				<dataset seriesName="@YEAR@" color="8BBA00" showValues="0">
				<set value="sql(select count(*) from worklog where user_id = @USERID@ and STATUS=1   and datediff(day, convert(datetime, log_day) , create_date) = 0  and year(log_day) = @YEAR@,%%)" />
				<set value="sql(select count(*)  from worklog where user_id = @USERID@ and STATUS=1  and datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day) = @YEAR@,%%)" />
				</dataset>
			</chart> 	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作日志图表</dictsOption>
    <chartTypeId>13</chartTypeId>
  </field>
  
  <field>
    <chartCode>Multi-series Column 3D</chartCode>
    <chartName>按年个人日志完成统计多系列柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@USERNAME@日志完成统计" shownames="1" showvalues="0"  baseFontSize="12">
				<categories>
				<category label="已写日志" />
				<category label="补写日志" />
				</categories>
				<dataset seriesName="@LASTYEAR@" color="F6BD0F" showValues="0">
				<set value="sql(select count(*) from worklog where user_id = @USERID@ and STATUS=1 and datediff(day, convert(datetime, log_day) , create_date) = 0 and year(log_day) = @LASTYEAR@,%%)" />
				<set value="sql(select count(*)  from worklog where user_id = @USERID@ and STATUS=1  and datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day) = @LASTYEAR@,%%)" />
				</dataset>
				<dataset seriesName="@YEAR@" color="8BBA00" showValues="0">
				<set value="sql(select count(*) from worklog where user_id = @USERID@ and STATUS=1   and datediff(day, convert(datetime, log_day) , create_date) = 0  and year(log_day) = @YEAR@,%%)" />
				<set value="sql(select count(*)  from worklog where user_id = @USERID@ and STATUS=1  and datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day) = @YEAR@,%%)" />
				</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作日志图表</dictsOption>
    <chartTypeId>14</chartTypeId>
  </field>
   
  <field>
    <chartCode>Multi-series Line 2D</chartCode>
    <chartName>按月个人日志完成统计多系列线状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年月度@USERNAME@日志完成统计"  lineThickness="1" showValues="0" formatNumberScale="0" anchorRadius="2"   divLineAlpha="20" divLineColor="CC3300" divLineIsDashed="1" showAlternateHGridColor="1" alternateHGridAlpha="5" alternateHGridColor="CC3300" shadowAlpha="40" labelStep="2" numvdivlines="5" chartRightMargin="35" bgColor="FFFFFF,CC3300" bgAngle="270" bgAlpha="10,10" baseFontSize="12" >
				<categories >
				<category label="1月" />
				<category label="2月" />
				<category label="3月" />
				<category label="4月" />
				<category label="5月" />
				<category label="6月" />
				<category label="7月" />
				<category label="8月" />
				<category label="9月" />
				<category label="10月" />
				<category label="11月" />
				<category label="12月" />
				</categories>
				<dataset seriesName="已写日志" color="1D8BD1" anchorBorderColor="1D8BD1" anchorBgColor="1D8BD1">
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@ and STATUS=1  and year(log_day) = @YEAR@ and month(log_day) =1,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =2,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =3,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =4,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =5,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =6,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =7,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =8,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =9,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =10,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =11,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) = 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =12,%%)" />
				</dataset>
				<dataset seriesName="补写日志" color="F1683C" anchorBorderColor="F1683C" anchorBgColor="F1683C">
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =1,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =2,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =3,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =4,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =5,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =6,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =7,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =8,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =9,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =10,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =11,%%)" />
				<set value="sql(select count(*) from worklog where datediff(day, convert(datetime, log_day) , create_date) > 0 and user_id = @USERID@  and STATUS=1 and year(log_day) = @YEAR@ and month(log_day) =12,%%)" />
				</dataset>
				<styles>                
				<definition>
				<style name="CaptionFont" type="font" size="12"/>
				</definition>
				<application>
				<apply toObject="CAPTION" styles="CaptionFont" />
				<apply toObject="SUBCAPTION" styles="CaptionFont" />
				</application>
				</styles>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作日志图表</dictsOption>
    <chartTypeId>15</chartTypeId>
  </field>
  
  <field>
    <chartCode>Scroll Column 2D</chartCode>
    <chartName>按年部门员工日志完成统计滚动柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@DEPTNAME@员工日志完成统计" shownames="1" showvalues="0"  useRoundEdges="1" legendBorderAlpha="0" baseFontSize="12">
				<categories>
				<category label="sql(select username from (select sp.id a,sp.dept_id b,sp.parent_id c, sp.name n,su.username username, su.id si from SYSTEM_POSITION sp,system_users su,system_positionmember spm where sp.id=spm.position_id and su.id = spm.user_id and su.status = 1 and sp.DELETEDSTATUS=0 and sp.dept_id = @DEPTID@ ) as s1 where c =  (select sp2.id d from SYSTEM_POSITION sp2,system_users su2,system_positionmember spm2 where sp2.id=spm2.position_id and su2.id = spm2.user_id and su2.status = 1 and sp2.DELETEDSTATUS=0 and sp2.dept_id = @DEPTID@ and su2.id=@USERID@) ,%%)" />
				</categories>
				<dataset seriesName="补写日志" color="AFD8F8" showValues="0">
				<set value="sql(select count(*)  from worklog wlog,system_users suser   where user_id = suser.id and suser.STATUS=1 and wlog.STATUS=1  and  datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day)=@YEAR@ and  suser.username = @param_1@,%%)" />
				</dataset>
				<dataset seriesName="已写日志" color="1D8BD1" showValues="0">
				<set value="sql(select count(*) from worklog wlog,system_users suser  where user_id = suser.id and suser.STATUS=1 and wlog.STATUS=1  and  datediff(day, convert(datetime, log_day) , create_date) = 0 and wlog.user_id = suser.id and year(log_day)=@YEAR@ and  suser.username = @param_1@,%%)" />
				</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作日志图表</dictsOption>
    <chartTypeId>23</chartTypeId>
  </field>
  
  <field>
    <chartCode>Scroll Column 2D</chartCode>
    <chartName>按月部门员工日志完成统计滚动柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@DEPTNAME@员工日志完成统计" shownames="1" showvalues="0"  useRoundEdges="1"  legendBorderAlpha="0"  baseFontSize="12">
				<categories>
				<category label="sql(select username from (select sp.id a,sp.dept_id b,sp.parent_id c, sp.name n,su.username username, su.id si from SYSTEM_POSITION sp,system_users su,system_positionmember spm where sp.id=spm.position_id and su.id = spm.user_id and su.status = 1 and sp.DELETEDSTATUS=0 and sp.dept_id = @DEPTID@ ) as s1 where c =  (select sp2.id d from SYSTEM_POSITION sp2,system_users su2,system_positionmember spm2 where sp2.id=spm2.position_id and su2.id = spm2.user_id and su2.status = 1 and sp2.DELETEDSTATUS=0 and sp2.dept_id = @DEPTID@ and su2.id=@USERID@) ,%%)" />
				</categories>
				<dataset seriesName="补写日志" color="AFD8F8" showValues="0">
				<set value="sql(select count(*)  from worklog wlog,system_users suser   where user_id = suser.id and suser.STATUS=1 and wlog.STATUS=1  and  datediff(day, convert(datetime, log_day) , create_date) > 0 and year(log_day)=@YEAR@ and month(log_day)=@MONTH@ and  suser.username = @param_1@,%%)" />
				</dataset>
				<dataset seriesName="已写日志" color="1D8BD1" showValues="0">
				<set value="sql(select count(*) from worklog wlog,system_users suser  where  user_id = suser.id and suser.STATUS=1 and wlog.STATUS=1  and  datediff(day, convert(datetime, log_day) , create_date) = 0  and year(log_day)=@YEAR@ and month(log_day)=@MONTH@ and  suser.username = @param_1@,%%)" />
				</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作日志图表</dictsOption>
    <chartTypeId>23</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月个人任务完成百分比统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@USERNAME@任务完成百分比统计" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@ and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and month(tub.create_date)=@MONTH@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />    
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Bar 2D</chartCode>
    <chartName>某周流程利用率最高Top10条状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="一周流程利用率最高Top10" yAxisName="利用数" xAxisName="流程名称" showValues="0"  formatNumberScale="0" chartRightMargin="30" baseFontSize="12">
			  <loop function="sql(select top 10 w.name as s1, count(*) as s2   from workflow_file wf,workflow w where wf.flow_id = w.id and wf.flow_flag != 0 and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate() group by w.name order by s2 desc  ,%%)"/>
		    </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>2</chartTypeId>
  </field>
   
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月个人任务完成百分比统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" caption="@YEAR@年@MONTH@月@USERNAME@任务完成百分比统计" baseFontSize="12">
	          <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@ and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and month(tub.create_date)=@MONTH@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />    
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年个人任务完成百分比统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" caption="@YEAR@年@USERNAME@任务完成百分比统计" baseFontSize="12" >
               <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年个人任务完成百分比统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@USERNAME@任务完成百分比统计" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年个人任务完成百分比统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		   <chart palette="2" showBorder="1" caption="@YEAR@年@USERNAME@任务完成百分比统计" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" /> 
			</chart> 	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Bar 2D</chartCode>
    <chartName>按年个人任务完成百分比统计条状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		   <chart caption="@YEAR@年@USERNAME@任务完成百分比统计" xAxisName="任务完成百分比"  showValues="0"  formatNumberScale="0" chartRightMargin="30" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" /> 
		  </chart> 	
		]]>
    </xml><depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>2</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月个人任务完成百分比统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@USERNAME@任务完成百分比统计" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@ and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and month(tub.create_date)=@MONTH@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月个人任务完成百分比统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@MONTH@月@USERNAME@任务完成百分比统计" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@ and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and month(tub.create_date)=@MONTH@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Bar 2D</chartCode>
    <chartName>按月个人任务完成百分比统计条状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@MONTH@月@USERNAME@任务完成百分比统计" xAxisName="任务完成百分比"  showValues="0"  formatNumberScale="0" chartRightMargin="30" baseFontSize="12" >
			  <set label="小于50%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@ and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" /> 
			  <set label="50%25-75%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" /> 
			  <set label="75%-100%" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@  and month(tub.create_date)=@MONTH@  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" /> 
			  <set label="完成100%25" value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=@MONTH@   and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100  ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>2</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年个人任务状态完成情况统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@USERNAME@任务状态完成情况统计" baseFontSize="12" >
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and tu.task_id=t.id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and tu.task_id=t.id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and tu.task_id=t.id and tu.user_id=@USERID@ and year(t.stop_date) = @YEAR@  ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and tu.task_id=t.id and tu.user_id=@USERID@ ,%%)" /> 
			 </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年个人任务状态完成情况统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" caption="@YEAR@年@USERNAME@任务状态完成情况统计" baseFontSize="12" >
              <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and tu.task_id=t.id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and tu.task_id=t.id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and tu.task_id=t.id and tu.user_id=@USERID@ and year(t.stop_date) = @YEAR@  ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and tu.task_id=t.id and tu.user_id=@USERID@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年个人任务状态完成情况统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@USERNAME@任务状态完成情况统计" baseFontSize="12">
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and tu.task_id=t.id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and tu.task_id=t.id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and tu.task_id=t.id and tu.user_id=@USERID@ and year(t.stop_date) = @YEAR@  ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and tu.task_id=t.id and tu.user_id=@USERID@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年个人任务状态完成情况统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@USERNAME@任务状态完成情况统计" baseFontSize="12">
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and tu.task_id=t.id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and tu.task_id=t.id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and tu.task_id=t.id and tu.user_id=@USERID@ and year(t.stop_date) = @YEAR@  ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and tu.task_id=t.id and tu.user_id=@USERID@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年个人任务状态完成情况统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@USERNAME@任务状态完成情况统计" xAxisName="任务状态" yAxisName="任务完成个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and tu.task_id=t.id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and tu.task_id=t.id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and tu.task_id=t.id and tu.user_id=@USERID@ and year(t.stop_date) = @YEAR@  ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and tu.task_id=t.id and tu.user_id=@USERID@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年部门任务状态完成情况统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@DEPTNAME@任务状态完成情况统计" baseFontSize="12" >
			   <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@  and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年部门任务状态完成情况统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70"  caption="@YEAR@年@DEPTNAME@任务状态完成情况统计" baseFontSize="12" >
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@  and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>    
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年部门任务状态完成情况统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		   <chart palette="2" showBorder="1" caption="@YEAR@年@DEPTNAME@任务状态完成情况统计" baseFontSize="12" >
			   <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@  and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />   
			</chart> 	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年部门任务状态完成情况统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@DEPTNAME@任务状态完成情况统计" xAxisName="任务状态" yAxisName="任务完成个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
			   <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@  and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按周流程处理情况统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="按周流程处理情况统计"  baseFontSize="12">
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where w.flow_flag = 2 and wf.issent =2 ,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Bar 2D</chartCode>
    <chartName>某月流程利用率最高Top10条状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@MONTH@月流程利用率最高Top10" yAxisName="利用数" xAxisName="流程名称" showValues="0"  formatNumberScale="0" chartRightMargin="30" baseFontSize="12">
			  <loop function="sql(select top 10 w.name as s1, count(*) as s2   from workflow_file wf,workflow w where wf.flow_id = w.id and wf.flow_flag != 0 and month(wf.submitdate)=@MONTH@  group by w.name order by s2 desc,%%)"/>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>2</chartTypeId>
  </field>
  
  <field>
    <chartCode>Bar 2D</chartCode>
    <chartName>某年流程利用率最高Top10条状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年流程利用率最高Top10" yAxisName="利用数" xAxisName="流程名称" showValues="0"  formatNumberScale="0" chartRightMargin="30" baseFontSize="12">
			   <loop function="sql(select top 10 w.name as s1, count(*) as s2   from workflow_file wf,workflow w where wf.flow_id = w.id and wf.flow_flag != 0 and year(wf.submitdate)=@YEAR@  group by w.name order by s2 desc,%%)"/>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>2</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按周个人文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@USERNAME@文件超时处理统计"  yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
		    	<loop function="sql(select  ('星期'+cast((datepart(weekday, wfinbox.startdate)-1) as  varchar)) as s1 ,count(distinct wf.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = @USERID@  group by datepart(weekday, wfinbox.startdate),%%)"  />
		  	</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按周个人文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按周@USERNAME@文件超时处理统计" xAxisName="日期" yAxisName="超时处理流程个数" baseFontSize="12" >
			     <loop function="sql(select  ('星期'+cast((datepart(weekday, wfinbox.startdate)-1) as  varchar)) as s1 ,count(distinct wf.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = @USERID@  group by datepart(weekday, wfinbox.startdate),%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月个人文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按月@USERNAME@文件超时处理统计" xAxisName="日期" yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12" >
			   <loop function="sql(select ( cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月'+cast((datepart(dd, wfinbox.startdate)) as  varchar)+'日') as s1 ,count(distinct wfinbox.id) as s2 	from workflow_fileinbox wfinbox,workflow_file wf  where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and  wfinbox.user_id = @USERID@   group by month(wfinbox.startdate),day(wfinbox.startdate) ,%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按月个人文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按月@USERNAME@文件超时处理统计"  xAxisName="日期" yAxisName="超时处理流程个数" baseFontSize="12" >
				  <loop function="sql(select ( cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月'+cast((datepart(dd, wfinbox.startdate)) as  varchar)+'日') as s1 ,count(distinct wfinbox.id) as s2 	from workflow_fileinbox wfinbox,workflow_file wf  where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and  wfinbox.user_id = @USERID@   group by month(wfinbox.startdate),day(wfinbox.startdate) ,%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年个人文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按年@USERNAME@文件超时处理统计" xAxisName="月份" yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				 <loop function="sql(select  (cast((datepart(yy, wfinbox.startdate)) as  varchar)+'年'+cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月') as s1  ,count(distinct wf.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf where wfinbox.file_id = wf.id and wfinbox.user_id = @USERID@ and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))     group by year(wfinbox.startdate),month(wfinbox.startdate),%%)"  />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按年个人文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按年@USERNAME@文件超时处理统计"  xAxisName="月份" yAxisName="超时处理流程个数" baseFontSize="12">
			  <loop function="sql(select  (cast((datepart(yy, wfinbox.startdate)) as  varchar)+'年'+cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月') as s1  ,count(distinct wf.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf where wfinbox.file_id = wf.id and wfinbox.user_id = @USERID@ and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))     group by year(wfinbox.startdate),month(wfinbox.startdate),%%)"  />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按周部门文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@DEPTNAME@文件超时处理统计"  baseFontSize="12" yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
			   <loop function="sql(select  ('星期'+cast((datepart(weekday, wfinbox.startdate)-1) as  varchar)) as s1 ,count(distinct wfinbox.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf ,system_users suser where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@  group by datepart(weekday, wfinbox.startdate),%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users> 
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按周部门文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按周@DEPTNAME@文件超时处理统计"   yAxisName="超时处理流程个数" baseFontSize="12">
			   <loop function="sql(select  ('星期'+cast((datepart(weekday, wfinbox.startdate)-1) as  varchar)) as s1 ,count(distinct wfinbox.id) as s2 from workflow_fileinbox wfinbox,workflow wf ,system_users suser where wfinbox.flow_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@  group by datepart(weekday, wfinbox.startdate),%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月部门文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按月@DEPTNAME@文件超时处理统计" xAxisName="日期" yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				  <loop function="sql(select ( cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月'+cast((datepart(dd, wfinbox.startdate)) as  varchar)+'日') as s1 ,count(distinct wfinbox.id) as s2 	from workflow_fileinbox wfinbox,workflow_file wf ,system_users suser where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and  wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@   group by month(wfinbox.startdate),day(wfinbox.startdate) ,%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按月部门文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按月@DEPTNAME@文件超时处理统计"  xAxisName="日期" yAxisName="超时处理流程个数" baseFontSize="12">
			   <loop function="sql(select  (cast((datepart(mm, wfinbox.startdate)) as  varchar)+'月'+cast((datepart(dd, wfinbox.startdate)) as  varchar)+'日') as s1 ,count(distinct wfinbox.id) as s2 from workflow_fileinbox wfinbox,workflow_file wf ,system_users suser where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and  wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@  group by month(wfinbox.startdate),day(wfinbox.startdate),%%)"  />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年部门文件超时处理统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按年@DEPTNAME@文件超时处理统计" xAxisName="月份" yAxisName="超时处理流程个数" showValues="0"  formatNumberScale="0" baseFontSize="12"  useRoundEdges="1" >
				<loop function="sql(select a as s1 ,sum(b) as s2 from (select (cast((datepart(yy, wfinbox.startdate)) as  varchar)+'年'+cast((datepart(mm, wfinbox.startdate)) as  varchar) +'月') a ,count(distinct wfinbox.id) b from workflow_fileinbox wfinbox,workflow_file wf ,system_users suser where wfinbox.file_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@ and year(wfinbox.startdate)=@YEAR@  group by wfinbox.startdate) ab  where ab.a = ab.a group by ab.a,%%)"/>  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按年部门文件超时处理统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@DEPTNAME@文件超时处理统计"  xAxisName="月份" yAxisName="超时处理流程个数" baseFontSize="12">
				<loop function="sql(select a as s1 ,sum(b) as s2 from (select (cast((datepart(yy, wfinbox.startdate)) as  varchar)+'年'+cast((datepart(mm, wfinbox.startdate)) as  varchar) +'月') a ,count(distinct wfinbox.id) b from workflow_fileinbox wfinbox,workflow wf ,system_users suser where wfinbox.flow_id = wf.id and (wfinbox.sentdate >  wfinbox.wishdate or (wfinbox.sentdate is null and wfinbox.wishdate < getdate()))  and wfinbox.user_id = suser.id and suser.dept_id = @DEPTID@ and year(wfinbox.startdate)=@YEAR@  group by wfinbox.startdate	) ab  where ab.a = ab.a group by ab.a,%%)"/>   
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Scroll Column 2D</chartCode>
    <chartName>按月个人任务完成情况统计滚动柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年月度@USERNAME@任务完成情况统计"  baseFontSize="12"  shownames="1" showvalues="0" useRoundEdges="1" legendBorderAlpha="0">
			<categories>
				<!-- label:显示名称, 可用sql取得数据表内容 以@param_1@方式带值到set标签value值的sql函数中-->	
				<category label="1月" />
				<category label="2月" />
				<category label="3月" />
				<category label="4月" />
				<category label="5月" />
			                     <category label="6月" />
			                     <category label="7月" />
			                     <category label="8月" />
			                     <category label="9月" />
			                     <category label="10月" />
			                     <category label="11月" />
			                     <category label="12月" />
			</categories>
			<!-- seriesName:栏目名称, 可用sql取得数据表内容 以@param_2@方式带值到set标签value值的sql函数中-->
			<dataset seriesName="未到50%" color="AFD8F8" showValues="0">
				<!-- value:显示值,可用sql取得数据表内容可调用@parm_1@、@param_2@参数 -->
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=1 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=2 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=3 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=4 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=5 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=6 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=7 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=8 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=9 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=10 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=11 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=12 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >0 and a<50  or (s!=3 and a=0),%%)" />
			
			</dataset>
			<dataset seriesName="完成50~75%" color="F6BD0F" showValues="0">
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=1 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=2 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=3 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=4 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=5 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=6 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=7 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=8 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=9 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=10 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=11 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=12 and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=50 and a<75  ,%%)" />
			
			</dataset>
			<dataset seriesName="完成75~99%" color="8BBA00" showValues="0">
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=1  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=2  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=3  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=4  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=5  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=6  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=7  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=8  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=9  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=10  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=11  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=12  and tub.user_id=@USERID@ group by t.id,t.status) as f where a >=75 and a<100  ,%%)" />
			
			</dataset>
			<dataset seriesName="完成100%" showValues="0">
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=1 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=2 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=3 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=4 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=5 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=6 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=7 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=8 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=9 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=10 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=11 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			<set value="sql(select count(*) from (select max(tub.finish) a,t.status s from task t left join task_user_hb tub on (tub.task_id = t.id) where t.status!=0  and year(tub.create_date) = @YEAR@ and month(tub.create_date)=12 and tub.user_id=@USERID@ group by t.id,t.status) as f where a = 100 ,%%)" />
			
			</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>23</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月个人任务状态统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@USERNAME@任务状态统计" baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and t.id=tu.task_id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t,task_user tu  where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and year(t.stop_date) = @YEAR@ and month(t.stop_date) = @MONTH@ and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and t.id=tu.task_id and tu.user_id=@USERID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月个人任务状态统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@USERNAME@任务状态统计"    baseFontSize="12"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
			  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and t.id=tu.task_id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t,task_user tu  where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and year(t.stop_date) = @YEAR@ and month(t.stop_date) = @MONTH@ and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and t.id=tu.task_id and tu.user_id=@USERID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月个人任务状态统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@USERNAME@任务状态统计" baseFontSize="12" >
			  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and t.id=tu.task_id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t,task_user tu  where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and year(t.stop_date) = @YEAR@ and month(t.stop_date) = @MONTH@ and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and t.id=tu.task_id and tu.user_id=@USERID@ ,%%)" />    
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月个人任务状态统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@MONTH@月@USERNAME@任务状态统计" baseFontSize="12" >
			  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and t.id=tu.task_id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t,task_user tu  where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and year(t.stop_date) = @YEAR@ and month(t.stop_date) = @MONTH@ and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and t.id=tu.task_id and tu.user_id=@USERID@ ,%%)" />    
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月个人任务状态统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@USERNAME@任务状态统计"    baseFontSize="12"   xAxisName="任务状态" yAxisName="任务数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
			  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			<set label="未启动" value="sql(select count(distinct(t.id)) from task t,task_user tu where t.status =0 and t.id=tu.task_id and tu.user_id=@USERID@  ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t,task_user tu  where t.status =1 and t.end_date >= convert(varchar(10), getdate(), 23) and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and tub.user_id=@USERID@ ,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status = 3 and year(t.stop_date) = @YEAR@ and month(t.stop_date) = @MONTH@ and t.id=tu.task_id and tu.user_id=@USERID@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu where t.status =4 and t.id=tu.task_id and tu.user_id=@USERID@ ,%%)" />    
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月部门任务状态统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@DEPTNAME@任务状态统计" baseFontSize="12" >
				  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ and month(t.stop_date)=@MONTH@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月部门任务状态统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  caption="@YEAR@年@MONTH@月@DEPTNAME@任务状态统计" baseFontSize="12"   enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				   <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				  
			    <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ and month(t.stop_date)=@MONTH@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月部门任务状态统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@DEPTNAME@任务状态统计" baseFontSize="12" >
				  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				 <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ and month(t.stop_date)=@MONTH@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月部门任务状态统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@MONTH@月@DEPTNAME@任务状态统计" baseFontSize="12" >
			  <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ and month(t.stop_date)=@MONTH@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月部门任务状态统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@DEPTNAME@任务状态统计" baseFontSize="12"  xAxisName="月份" yAxisName="任务数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
			   <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@ and month(tub.create_date) = @MONTH@ and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ and month(t.stop_date)=@MONTH@,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年部门任务状态完成情况统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@DEPTNAME@任务状态统计" baseFontSize="12" >
			   <!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				 <set label="未启动" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =0 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@ ,%%)" /> 
			  <set label="进行中" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =1 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id = @DEPTID@  and t.end_date >= convert(varchar(10), getdate(), 23) ,%%)" /> 
			  <set label="已完成" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id) left join system_users u on (t.user_id = u.id) where t.finish = 100 and year(tub.create_date) = @YEAR@  and u.dept_id=@DEPTID@,%%)" /> 
			  <set label="已中止" value="sql(select count(distinct(t.id)) from task t left join task_user_hb tub on (tub.task_id = t.id),system_users u where t.status = 3 and t.user_id = u.id and u.dept_id=@DEPTID@ and year(t.stop_date) = @YEAR@ ,%%)" /> 
			  <set label="已过期" value="sql(select count(distinct(t.id)) from task t ,task_user tu,system_users u where t.status =4 and tu.task_id=t.id and u.id = tu.user_id and u.dept_id=@DEPTID@ ,%%)" />  
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>任务管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按周个人流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@USERNAME@流程处理办文数量统计"  baseFontSize="12" xAxisName="处理状态" yAxisName="流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
					<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				  <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按周个人流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按周@USERNAME@流程处理办文数量统计" baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and wf.issent =2  ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按周个人流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="按周@USERNAME@流程处理办文数量统计" baseFontSize="12"  >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@  and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按周个人流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="按周@USERNAME@流程处理办文数量统计" baseFontSize="12"    enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按周个人流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@USERNAME@流程处理办文数量统计" baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按周个人流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="按周@USERNAME@流程处理办文数量统计" baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag != 0 and wf.user_id=@USERID@  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@  and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() ,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月个人流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计" baseFontSize="12" xAxisName="处理状态" yAxisName="流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@  and w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按月个人流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计"    baseFontSize="12" xAxisName="处理状态" yAxisName="流程个数" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月个人流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月个人流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计"  baseFontSize="12"   enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	 
				 <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月个人流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@  and w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月个人流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@MONTH@月@USERNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年个人流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年个人流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			 </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按年个人流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12"   xAxisName="处理状态" yAxisName="流程个数"  >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年个人流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12"  >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	  
				<set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id  and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年个人流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年个人流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@USERNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from workflow_file wf where wf.flow_flag !=  0 and wf.user_id=@USERID@  and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  wf.user_id = @USERID@ and w.user_id != wf.user_id and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and   wf.user_id = @USERID@ and w.flow_flag = 2 and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ ,%%)" /> 
				  <set label="已结束" value="sql(select  count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where  w.flow_flag = 1 and wf.user_id = @USERID@ and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按周部门流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" />			   
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按周部门流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按周部门流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		   <chart palette="4" caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
			</chart> 	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按周部门流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"   enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按周部门流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按周部门流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="按周@DEPTNAME@流程处理办文数量统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate(),%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id)  where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23) and getDate() and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按月部门流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" showValues="0"  formatNumberScale="0" useRoundEdges="1">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2   ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
		  </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按月部门流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2  ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月部门流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2   ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月部门流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"   enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	
			<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2   ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月部门流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2  ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月部门流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@MONTH@月@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0  and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>按年部门流程处理办文数量统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数"  showValues="0"  formatNumberScale="0" useRoundEdges="1">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@  ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>按年部门流程处理办文数量统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"  xAxisName="处理状态" yAxisName="流程个数" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年部门流程处理办文数量统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年部门流程处理办文数量统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12"   enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@  ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2   ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年部门流程处理办文数量统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@  ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and wf.issent =2  ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
   
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年部门流程处理办文数量统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年@DEPTNAME@流程处理办文数量统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			   <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.dept_id = @DEPTID@ and wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
				  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@  and wf.issent =2 ,%%)" /> 
				  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 2 and u.dept_id = @DEPTID@ and w.user_id != wf.user_id  and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
				  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) left join system_users u on (wf.user_id = u.id) where w.flow_flag = 1 and u.dept_id = @DEPTID@ and year(wf.sentdate)=@YEAR@ and wf.issent =3 ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按周流程处理情况统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="按周程处理情况统计"  baseFontSize="12"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	 
				<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按周流程处理情况统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="按周流程处理情况统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按周流程处理情况统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="按周流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and wf.submitdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and wf.sentdate between CONVERT(varchar(100), dateadd(dd,-datepart(dw,getDate())+2,getDate()), 23)  and getDate(),%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按月流程处理情况统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年@MONTH@月流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			 <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where w.flow_flag = 2 and wf.issent =2 ,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按月流程处理情况统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70"  caption="@MONTH@月流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	 
				<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按月流程处理情况统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@MONTH@月流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按月流程处理情况统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@MONTH@月流程处理情况统计"  baseFontSize="12"  >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ and month(wf.submitdate)=@MONTH@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ and month(wf.sentdate)=@MONTH@,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>按年流程处理情况统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="@YEAR@年流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>按年流程处理情况统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4"  enableSmartLabels="1" enableRotation="0" bgColor="99CCFF,FFFFFF" bgAlpha="40,100" bgRatio="0,100" bgAngle="360" showBorder="1" startingAngle="70" caption="@YEAR@年流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->	 
				<set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>按年流程处理情况统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="@YEAR@年流程处理情况统计"  baseFontSize="12" >
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id  ) where w.flow_flag = 2 and wf.issent =2,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>按年流程处理情况统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" showBorder="1" caption="@YEAR@年流程处理情况统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			  <set label="已发起" value="sql(select count(*) from  workflow_file wf where wf.flow_flag !=  0 and year(wf.submitdate)=@YEAR@ ,%%)" /> 
			  <set label="办理中" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where w.flow_flag = 2 and wf.issent =2 ,%%)" /> 
			  <set label="已办理" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 2 and w.user_id != wf.user_id and year(wf.sentdate)=@YEAR@  ,%%)" /> 
			  <set label="已结束" value="sql(select count(distinct(w.id) ) from workflow_file w left join workflow_fileinbox wf on (wf.file_id = w.id ) where wf.issent =3 and  w.flow_flag = 1 and year(wf.sentdate)=@YEAR@ ,%%)" /> 
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>工作流统计图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 2D</chartCode>
    <chartName>知识维度热度统计饼状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="知识维度热度统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct  where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>8</chartTypeId>
  </field>
  
  <field>
    <chartCode>Pie 3D</chartCode>
    <chartName>知识维度热度统计饼状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="知识维度热度统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
			<loop function="sql(select Top 10 kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct  where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>9</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 2D</chartCode>
    <chartName>知识维度热度统计圆环二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="知识维度热度统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish),%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>5</chartTypeId>
  </field>
  
  <field>
    <chartCode>Doughnut 3D</chartCode>
    <chartName>知识维度热度统计圆环三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="4" caption="知识维度热度统计"  baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct  where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>6</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>知识维度热度统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识维度热度统计" xAxisName="知识维度" yAxisName="知识热度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct  where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>知识维度热度统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识维度热度统计" xAxisName="知识维度" yAxisName="知识热度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10  kct.name as s1, sum(k.flourish) as s2 from knowledge_knowledge_type kkt, knowledges k, knowledge_catalogy_type kct  where k.id = kkt.k_id and kct.id = kkt.t_id group by kct.name order by sum(k.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>知识部门活跃度统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识部门活跃度统计" xAxisName="部门" yAxisName="活跃度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10  d.name as s1, sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by d.name order by sum(f.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>知识部门活跃度统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识部门活跃度统计" xAxisName="部门" yAxisName="活跃度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 d.name as s1, sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by d.name order by sum(f.flourish) desc,%%)" />
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Scroll Column 2D</chartCode>
    <chartName>知识部门活跃度统计滚动柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识部门活跃度统计" xAxisName="部门" yAxisName="活跃度" shownames="1" showvalues="0"  useRoundEdges="1" legendBorderAlpha="0" baseFontSize="12">
			<categories>
				<!-- label:显示名称, 可用sql取得数据表内容 以@param_1@方式带值到set标签value值的sql函数中-->
			<loop function="sql(select Top 10 d.name as s1 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by d.name order by sum(f.flourish) desc ,%%)" />
				</categories>
			<!-- seriesName:栏目名称, 可用sql取得数据表内容 以@param_2@方式带值到set标签value值的sql函数中-->
			<dataset seriesName="@YEAR@" color="AFD8F8" showValues="0">
				<!-- value:显示值,可用sql取得数据表内容可调用@parm_1@、@param_2@参数 -->
				<set value="sql(select Top 10 sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id and d.name= @param_1@ group by d.name order by sum(f.flourish) desc,%%)" />
			</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>23</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 2D</chartCode>
    <chartName>知识员工活跃度统计柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识员工活跃度统计" xAxisName="员工" yAxisName="活跃度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 u.username as s1, sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by u.username order by sum(f.flourish) desc,%%)" />  
			  </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>3</chartTypeId>
  </field>
  
  <field>
    <chartCode>Column 3D</chartCode>
    <chartName>知识员工活跃度统计柱状三维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识员工活跃度统计" xAxisName="员工" yAxisName="活跃度" showValues="0"  formatNumberScale="0" useRoundEdges="1" baseFontSize="12">
				<!-- label:显示名称, value:显示值,可用sql取得数据表内容 -->
				<loop function="sql(select Top 10 u.username as s1, sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by u.username order by sum(f.flourish) desc,%%)" />  
			 </chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>4</chartTypeId>
  </field>
  
  <field>
    <chartCode>Scroll Column 2D</chartCode>
    <chartName>知识员工活跃度统计滚动柱状二维图</chartName>
    <chartCategory>FusionCharts</chartCategory>
    <status>0</status>
    <cacheLive>0</cacheLive>
    <cacheIdle>0</cacheIdle>
    <xml>
    	<![CDATA[
		    <chart palette="2" caption="知识员工活跃度统计" xAxisName="员工" yAxisName="活跃度" shownames="1" showvalues="0"  useRoundEdges="1" legendBorderAlpha="0" baseFontSize="12">
			<categories>
				<!-- label:显示名称, 可用sql取得数据表内容 以@param_1@方式带值到set标签value值的sql函数中-->
			<loop function="sql(select Top 10 u.username as s1 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  group by u.username order by sum(f.flourish) desc ,%%)" />
				</categories>
			<!-- seriesName:栏目名称, 可用sql取得数据表内容 以@param_2@方式带值到set标签value值的sql函数中-->
			<dataset seriesName="@YEAR@" color="AFD8F8" showValues="0">
				<!-- value:显示值,可用sql取得数据表内容可调用@parm_1@、@param_2@参数 -->
				<set value="sql(select Top 10 sum(f.flourish) as s2 from system_depts d,system_users u ,knowledge_user_flourish f where u.dept_id = d.id and f.user_id = u.id  and u.username=@param_1@ group by d.name order by sum(f.flourish) ,%%)" />
			</dataset>
			</chart>	
		]]>
    </xml>
    <depts>2</depts>
    <users>2</users>
    <dictsOption>知识管理图表</dictsOption>
    <chartTypeId>23</chartTypeId>
  </field>

</chartData>